Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a ...
The SUBSTITUTE Function was introduced in MS Excel 2007 and is available under Excel Text functions. It will replace one or more text strings with another ...